create or replace view vac_page_comp_4_1 as
with pc as
(
select
 workspace,
 workspace_display_name,
 application_id,
 application_name,
 page_id,
 page_name,
 item_name,
 to_char(execution_sequence) execution_sequence,
 computation_point,
 computation_type,
 computation,
 condition_type,
 condition_type_code,
 condition_expression1,
 condition_expression2,
 error_message,
 build_option,
 authorization_scheme,
 authorization_scheme_id,
 last_updated_by,
 last_updated_on,
 component_comment,
 component_signature,
 computation_id
 from apex_application_page_comp
)
select
 workspace,
 workspace_display_name,
 application_id,
 application_name,
 page_id,
 page_name,
 authorization_scheme_id,
 component_signature,
 computation_id,
 last_updated_by,
 last_updated_on,
 item_name,
 u_value,
 u_name
from pc
UNPIVOT INCLUDE NULLS
 ( u_value
   FOR    u_name
   IN
   (
     execution_sequence,
     computation_point,
     computation_type,
     computation,
     condition_type,
     condition_type_code,
     condition_expression1,
     condition_expression2,
     error_message,
     build_option,
     authorization_scheme,
     component_comment
   )
 );

